Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


PreviousPrevious NextNext

~John Cisgerotherader 13.Jan.04 05:25 PM a Web browser
Domino Designer All Releases All Platforms

I've been scouring the Notes help documentation and forums on the web for several days now trying to determine if Notes will look up a field to determine if it is unique. I found this code snippet in the Notes 5 forum and made a few small changes to it for my application. However, while the first part of the code works and I get an error message if the field is empty, the second part where the value is compared against existing values to determine that it is indeed unique, I never get an error. Does anyone have any insight? Many thanks!

@If(RequestNo = "";
@Failure("You have to enter a Req Number");
@DbLookup("":"NoCache"; "" : "" ; "All Reqs"; RequestNo; "RequestNo"));
@IsNewDoc = 0;
@Failure("This Req Number Already Exists."))

Here's a link to the original posting:

Again, thanks for helping!


Unique Field Lookup Issue (~John Cisgeroth... 13.Jan.04)
. . RE: Unique Field Lookup Issue (~Mario Lopkiste... 13.Jan.04)
. . RE: Unique Field Lookup Issue (~Yentl Cisniter... 13.Jan.04)
. . . . RE: Unique Field Lookup Issue (~Bill Frokimari... 14.Jan.04)
. . . . . . Unique Field Lookup Issue - Thanks!... (~John Cisgeroth... 14.Jan.04)

  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS